Model Table STATISTIC PERIOD
This model dimension represents Statistic Period and is based on the IFS Cloud
dimension DIM_STATISTIC_PERIOD. All models that refers to this dimension will
have the attributes described below.
Attributes
| Attribute |
Description (where applicable) |
| ID | |
| Statistic Period | Built as STAT_YEAR_NO - STAT_PERIOD_NO as STAT_YEAR_PERIOD. |
| Statistic Period Begin Date | This is the first date in the period. The same day may
not be included in more than one period. |
| Statistic Period Description | Represents the description of the statistic period. |
| Statistic Period End Date | The last date in the period. The same day may not be
included in more than one period. |
| Statistic Period Period Closed | Represents the period is open or closed. |
| Statistic Period Period Closed Desc | |
| Statistic Period Stat Period No | Represents the period for begin and end date. |
| Statistic Period Stat Year No | Represents the year for begin and end date |
| Hierarchy |
Level |
| StatPeriodHy | |
| Statistic Period Stat Year No |
| Statistic Period |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| STATISTIC PERIOD | DIM_STATISTIC_PERIOD_TM | DIM_STATISTIC_PERIOD_BI | DIM_STATISTIC_PERIOD | On Line |